Apple Reference & Presentation Library 1992 Spring

home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presentation Library 1992 Spring / ARPL-Spring-1992_Partner_Edition.iso / 5-Fonts & Software / Software Applications / Time Management / MacProject II v2.5 Demo / Cash Flow Script / Cash Flow Script
Unknown | 1991-05-16 | 12.7 KB | [RsSc/Rslv]
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`10%`	dexvert	OS/2 Bitmap Array `(archive/os2BitmapArray)`	magic	Supported
`10%`	dexvert	OS/2 Icon File `(image/icoOS2)`	magic	Supported
`100%`	file	data	default
`100%`	TrID	OS/2 Bitmap Graphics Array (generic)	default (weak)
`100%`	dexmagic	PrintFox/Pagefox WEAK	default
`100%`	gt2	Kopftext: 'BAT_BTSC0101'	default (weak)
id metadata
key	value
macFileType	`[RsSc]`
macFileCreator	`[Rslv]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 42 41 54 5f 42 54 53 43 | 30 31 30 31 02 2b 00 00 |BAT_BTSC|0101.+..|
|00000010| 6e 07 00 00 c8 06 00 00 | c8 06 00 00 c8 06 00 00 |n.......|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 06 00 |........|........|
|00000050| 0b 00 00 00 00 00 00 00 | 18 00 00 00 00 00 00 00 |........|........|
|00000060| 00 f4 00 02 18 00 00 00 | 00 00 00 00 00 f4 00 04 |........|........|
|00000070| fd 04 1b 00 00 1b 00 00 | 00 f9 f2 70 00 1b 00 00 |........|...p....|
|00000080| 01 f9 f8 1a 00 00 18 00 | 00 00 00 00 00 08 40 3a |........|......@:|
|00000090| f2 1c 00 1b 00 00 02 f9 | f8 1b 00 00 03 f9 f8 fd |........|........|
|000000a0| 04 1b 00 01 1b 00 00 04 | f9 f8 1d 40 00 fd 39 23 |........|...@..9#|
|000000b0| 00 35 54 68 65 72 65 20 | 69 73 20 6e 6f 74 20 65 |.5There |is not e|
|000000c0| 6e 6f 75 67 68 20 43 61 | 73 68 20 46 6c 6f 77 20 |nough Ca|sh Flow |
|000000d0| 64 61 74 61 20 74 6f 20 | 63 72 65 61 74 65 20 61 |data to |create a|
|000000e0| 20 67 72 61 70 68 2e fd | 03 01 01 fc f6 00 00 fd | graph..|........|
|000000f0| 06 00 00 00 00 00 fd 0e | 08 01 01 01 01 07 07 00 |........|........|
|00000100| 00 00 00 ff 00 fd 17 00 | 06 00 12 4d 50 20 43 61 |........|...MP Ca|
|00000110| 73 68 20 46 6c 6f 77 20 | 54 61 62 6c 65 fe 40 18 |sh Flow |Table.@.|
|00000120| 00 00 00 00 00 00 00 00 | 39 f2 14 00 fd 04 1a 04 |........|9.......|
|00000130| 01 18 00 00 00 00 00 00 | f0 3f fa 1d 0c 00 18 00 |........|.?......|
|00000140| 00 00 00 00 00 00 00 fa | fb f6 00 00 fd 04 1a 04 |........|........|
|00000150| 01 fd 05 1a 05 00 0d fd | 05 1a 05 00 04 fd 05 1a |........|........|
|00000160| 05 00 03 fd 05 1a 05 00 | 05 fd 13 08 01 01 01 01 |........|........|
|00000170| 0c 08 0f 00 00 00 00 00 | 00 ff 7f ff 00 fd 02 0c |........|........|
|00000180| fd 02 0c fd 13 08 01 01 | 01 01 0c 08 0f 00 00 fe |........|........|
|00000190| 7f 00 00 00 00 ff 00 fd | 02 0c 1b 00 00 05 f9 f4 |........|........|
|000001a0| 00 00 fd 0f 0f 03 01 00 | 09 48 65 6c 76 65 74 69 |........|.Helveti|
|000001b0| 63 61 fd 07 19 01 01 02 | 70 08 fd 14 17 00 08 53 |ca......|p......S|
|000001c0| 74 61 72 74 69 6e 67 01 | 07 07 01 00 01 00 ff fd |tarting.|........|
|000001d0| 16 17 00 0a 50 6c 61 6e | 20 43 6f 73 74 73 01 07 |....Plan| Costs..|
|000001e0| 07 01 00 02 00 ff fd 17 | 17 00 0b 50 6c 61 6e 20 |........|...Plan |
|000001f0| 49 6e 63 6f 6d 65 01 07 | 07 01 00 03 00 ff fd 18 |Income..|........|
|00000200| 17 00 0c 41 63 74 75 61 | 6c 20 43 6f 73 74 73 01 |...Actua|l Costs.|
|00000210| 07 07 01 00 04 00 ff fd | 19 17 00 0d 41 63 74 75 |........|....Actu|
|00000220| 61 6c 20 49 6e 63 6f 6d | 65 01 07 07 01 00 05 00 |al Incom|e.......|
|00000230| ff fd 12 17 00 06 45 6e | 64 69 6e 67 01 07 07 01 |......En|ding....|
|00000240| 00 06 00 ff fd 10 17 00 | 04 50 6c 61 6e 01 07 07 |........|.Plan...|
|00000250| 01 00 07 00 ff fd 12 17 | 00 06 41 63 74 75 61 6c |........|..Actual|
|00000260| 01 07 07 01 00 08 00 ff | fd 28 17 01 1d 19 0c 43 |........|.(.....C|
|00000270| 61 73 68 20 46 6c 6f 77 | 20 2d 20 5f 19 08 6d 6d |ash Flow| - _..mm|
|00000280| 2f 64 64 2f 79 79 68 35 | ff 01 07 07 00 00 06 00 |/dd/yyh5|........|
|00000290| ff fd 13 08 01 01 01 01 | 0c 08 0f 00 00 01 00 01 |........|........|
|000002a0| 00 08 00 ff 00 fd 07 0f | 03 02 02 0e 00 fd 07 0f |........|........|
|000002b0| 03 03 00 01 42 fd 07 0f | 03 03 00 01 49 fd 28 08 |....B...|....I.(.|
|000002c0| 01 01 01 01 21 18 00 00 | 00 00 00 00 08 40 18 00 |....!...|.....@..|
|000002d0| 00 00 00 00 00 08 40 18 | 00 00 00 00 00 00 18 40 |......@.|.......@|
|000002e0| 1a 00 00 d8 ff 00 fd 05 | 0f 05 00 20 fd 06 0f 05 |........|... ....|
|000002f0| 02 01 09 fd 28 08 01 01 | 01 01 21 18 00 00 00 00 |....(...|..!.....|
|00000300| 00 00 1c 40 18 00 00 00 | 00 00 00 08 40 18 00 00 |...@....|....@...|
|00000310| 00 00 00 00 1c 40 1a 00 | 00 d8 ff 00 fd 06 0f 05 |.....@..|........|
|00000320| 00 50 81 fd 28 08 01 01 | 01 01 21 18 00 00 00 00 |.P..(...|..!.....|
|00000330| 00 00 20 40 18 00 00 00 | 00 00 00 08 40 18 00 00 |.. @....|....@...|
|00000340| 00 00 00 00 22 40 1a 00 | 00 d8 ff 00 fd 05 0f 05 |...."@..|........|
|00000350| 00 20 fd 06 0f 05 02 01 | 09 fd 28 08 01 01 01 01 |. ......|..(.....|
|00000360| 21 18 00 00 00 00 00 00 | 00 40 18 00 00 00 00 00 |!.......|.@......|
|00000370| 00 00 40 18 00 00 00 00 | 00 00 22 40 1a 00 00 d8 |..@.....|.."@....|
|00000380| ff 00 fd 09 0f 0a 00 04 | 54 4c 42 52 fb f6 00 02 |........|TLBR....|
|00000390| 1a 00 00 18 00 00 00 00 | 00 00 26 40 3a f2 98 00 |........|..&@:...|
|000003a0| 1a 00 00 2b 00 00 00 00 | 00 00 f0 3f 2d 00 00 00 |...+....|...?-...|
|000003b0| 00 00 00 22 40 95 f4 03 | 02 18 00 00 00 00 00 00 |..."@...|........|
|000003c0| 00 40 f4 03 01 1a 03 02 | 18 00 00 00 00 00 00 f0 |.@......|........|
|000003d0| 3f 1d 16 00 1a 03 02 18 | 00 00 00 00 00 00 f0 3f |?.......|.......?|
|000003e0| f7 1a 03 01 2e f4 03 01 | 1a 03 01 f5 4a 00 1a 03 |........|....J...|
|000003f0| 01 2a 00 00 00 00 00 00 | f0 3f f4 00 01 1a 00 00 |.*......|.?......|
|00000400| 1a 03 02 1d 10 00 1a 00 | 00 1a 03 02 f7 1a 00 01 |........|........|
|00000410| 2e f4 00 01 1a 00 01 f5 | 1b 00 fd 15 17 00 01 20 |........|....... |
|00000420| 01 0f 18 00 00 00 00 00 | 00 1c 40 1a 00 01 d4 ff |........|..@.....|
|00000430| 1d d5 ff 1d a0 ff fb f6 | 00 00 fd 04 08 01 05 18 |........|........|
|00000440| 00 00 00 00 00 00 f0 3f | fe 19 d1 fa fb f6 00 00 |.......?|........|
|00000450| fd 04 08 01 07 fd 59 15 | 00 04 01 31 08 0f 00 00 |......Y.|...1....|
|00000460| 14 00 0a 00 10 00 18 00 | 00 00 00 00 00 f0 3f 18 |........|......?.|
|00000470| 00 00 00 00 00 00 00 00 | 18 00 00 00 00 00 80 58 |........|.......X|
|00000480| 40 18 00 00 00 00 00 80 | 5f 40 e3 ff 01 22 18 00 |@.......|_@..."..|
|00000490| 00 00 00 00 00 1c 40 18 | 00 00 00 00 00 00 00 40 |......@.|.......@|
|000004a0| 18 00 00 00 00 00 00 22 | 40 1a 00 00 d8 d3 ff fd |......."|@.......|
|000004b0| 08 09 01 04 01 81 00 00 | fd 04 16 00 01 fd 05 16 |........|........|
|000004c0| 06 0e 03 fd 0c 09 01 04 | 01 81 00 04 00 01 81 00 |........|........|
|000004d0| fd 0e 0f 01 01 00 03 00 | 00 00 00 00 40 65 41 fd |........|....@eA.|
|000004e0| 06 0f 01 01 02 85 fd 0d | 09 01 04 01 81 00 06 00 |........|........|
|000004f0| 01 81 00 00 1a 00 00 18 | 00 00 00 00 00 00 34 40 |........|......4@|
|00000500| 3a f2 08 00 fd 05 16 04 | 02 00 fd 07 16 04 04 01 |:.......|........|
|00000510| 00 80 fd 0f 16 04 04 01 | 01 03 00 00 00 e0 ff ff |........|........|
|00000520| 6f 41 fd 07 16 04 04 01 | 02 80 fd 06 16 04 04 00 |oA......|........|
|00000530| 85 fd 0f 16 04 03 01 00 | 03 00 00 00 60 77 77 67 |........|....`wwg|
|00000540| 41 fd 0f 16 04 03 01 01 | 03 00 00 00 e0 ff ff 6f |A.......|.......o|
|00000550| 41 fd 07 16 04 03 01 02 | 80 fd 06 16 04 03 00 80 |A.......|........|
|00000560| fd 0d 09 01 04 01 81 00 | 06 00 01 83 00 00 fd 07 |........|........|
|00000570| 16 04 04 01 00 80 fd 0f | 16 04 04 01 01 03 00 00 |........|........|
|00000580| 00 e0 ff ff 6f 41 fd 07 | 16 04 04 01 02 81 fd 06 |....oA..|........|
|00000590| 16 04 04 00 85 fd 07 16 | 04 03 01 00 80 fd 0f 16 |........|........|
|000005a0| 04 03 01 01 03 00 00 00 | e0 ff ff 6f 41 fd 07 16 |........|...oA...|
|000005b0| 04 03 01 02 81 fd 06 16 | 04 03 00 80 fd 08 09 01 |........|........|
|000005c0| 04 01 81 00 00 fd 0e 08 | 00 01 01 01 07 07 00 00 |........|........|
|000005d0| 06 00 ff 00 fd 04 16 01 | 02 fd 05 16 01 00 04 fd |........|........|
|000005e0| 0e 08 01 01 01 01 07 07 | 00 00 11 00 ff 00 fd 0e |........|........|
|000005f0| 08 01 01 01 01 07 07 00 | 00 0a 00 ff 00 fd 04 08 |........|........|
|00000600| 01 07 fb f6 00 00 fd 12 | 1d 00 00 00 02 ff ff 02 |........|........|
|00000610| ff ff 00 02 50 19 02 70 | 08 fd 4f 1e 0b 00 3b 43 |....P..p|..O...;C|
|00000620| 6f 70 79 20 63 68 61 72 | 74 20 74 6f 20 43 6c 69 |opy char|t to Cli|
|00000630| 70 62 6f 61 72 64 20 61 | 6e 64 20 63 6c 6f 73 65 |pboard a|nd close|
|00000640| 20 77 6f 72 6b 73 68 65 | 65 74 20 77 69 74 68 6f | workshe|et witho|
|00000650| 75 74 20 73 61 76 69 6e | 67 3f 00 00 02 b4 00 02 |ut savin|g?......|
|00000660| b4 00 01 02 e8 17 02 d0 | 02 fd 06 0f 02 00 1c 00 |........|........|
|00000670| fd 2e 1e 00 01 00 0a 20 | 20 20 20 4e 6f 20 20 20 |....... |   No   |
|00000680| 20 01 00 0b 20 20 20 20 | 59 65 73 20 20 20 20 00 | ...    |Yes    .|
|00000690| 00 00 02 48 12 02 84 03 | 01 02 a0 05 02 38 04 fd |...H....|.....8..|
|000006a0| 06 1d 0b 01 82 00 fd 03 | 1d 09 fd 21 21 03 00 00 |........|...!!...|
|000006b0| 1b 27 43 61 73 68 20 46 | 6c 6f 77 20 73 63 72 69 |.'Cash F|low scri|
|000006c0| 70 74 3a 64 6f 6e 65 27 | 20 3d 20 30 fd 06 1d 0b |pt:done'| = 0....|
|000006d0| 01 83 00 fd 03 1d 08 fd | 21 21 03 00 00 1b 27 43 |........|!!....'C|
|000006e0| 61 73 68 20 46 6c 6f 77 | 20 73 63 72 69 70 74 3a |ash Flow| script:|
|000006f0| 64 6f 6e 65 27 20 3d 20 | 31 fd 03 1d 03 1a 00 02 |done' = |1.......|
|00000700| 18 00 00 00 00 00 00 f0 | 3f 39 f2 13 00 fd 08 09 |........|?9......|
|00000710| 01 04 01 81 00 00 fd 03 | 06 01 fd 03 01 01 fb fc |........|........|
|00000720| 09 00 6c 61 73 74 5f 72 | 6f 77 00 09 00 6c 6f 6f |..last_r|ow...loo|
|00000730| 70 5f 76 61 72 01 05 00 | 64 6f 6e 65 02 0d 00 74 |p_var...|done...t|
|00000740| 69 6d 65 5f 6e 6f 77 5f | 72 6f 77 03 09 00 6e 65 |ime_now_|row...ne|
|00000750| 67 5f 66 6c 61 67 04 10 | 01 00 4d 41 4b 45 5f 4e |g_flag..|..MAKE_N|
|00000760| 45 57 5f 53 48 45 45 54 | 94 00 00 00 0e 01 00 46 |EW_SHEET|.......F|
|00000770| 4f 52 4d 41 54 5f 54 41 | 42 4c 45 f1 00 00 00 0e |ORMAT_TA|BLE.....|
|00000780| 01 00 52 45 4d 4f 56 45 | 5f 44 41 54 45 53 35 03 |..REMOVE|_DATES5.|
|00000790| 00 00 0e 01 00 43 52 45 | 41 54 45 5f 43 48 41 52 |.....CRE|ATE_CHAR|
|000007a0| 54 f5 03 00 00 0d 01 00 | 41 53 4b 5f 54 4f 5f 43 |T.......|ASK_TO_C|
|000007b0| 4f 50 59 ab 05 00 00 0a | 01 00 47 45 54 5f 52 4f |OPY.....|..GET_RO|
|000007c0| 57 53 df 03 00 00 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |WS....{*|********|
|000007d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000007e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 43 41 53 |********|**** CAS|
|000007f0| 48 20 46 4c 4f 57 20 53 | 43 52 49 50 54 20 2a 2a |H FLOW S|CRIPT **|
|00000800| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000810| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000820| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0d 20 20 |********|****..  |
|00000830| 43 6f 70 79 72 69 67 68 | 74 20 a9 20 31 39 39 31 |Copyrigh|t . 1991|
|00000840| 20 43 6c 61 72 69 73 20 | 43 6f 72 70 2e 20 20 41 | Claris |Corp.  A|
|00000850| 6c 6c 20 72 69 67 68 74 | 73 20 72 65 73 65 72 76 |ll right|s reserv|
|00000860| 65 64 2e 0d 0d 20 20 4c | 41 53 54 20 4d 4f 44 49 |ed...  L|AST MODI|
|00000870| 46 49 45 44 3a 20 20 32 | 2f 31 34 2f 39 31 0d 0d |FIED:  2|/14/91..|
|00000880| 20 20 54 61 62 6c 65 73 | 20 55 73 65 64 3a 0d 09 |  Tables| Used:..|
|00000890| a5 20 20 43 61 73 68 20 | 46 6c 6f 77 20 54 61 62 |.  Cash |Flow Tab|
|000008a0| 6c 65 0d 0d 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |le..****|********|
|000008b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000008c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 44 45 46 49 4e |********|** DEFIN|
|000008d0| 45 20 47 4c 4f 42 41 4c | 20 56 41 52 49 41 42 4c |E GLOBAL| VARIABL|
|000008e0| 45 53 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ES *****|********|
|000008f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000900| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 44 45 46 49 |********|*}..DEFI|
|00000910| 4e 45 20 6c 61 73 74 5f | 72 6f 77 09 09 7b 20 4c |NE last_|row..{ L|
|00000920| 61 73 74 20 72 6f 77 20 | 6f 66 20 64 61 74 61 20 |ast row |of data |
|00000930| 6f 6e 20 74 68 65 20 43 | 61 73 68 20 46 6c 6f 77 |on the C|ash Flow|
|00000940| 20 54 61 62 6c 65 20 7d | 0d 44 45 46 49 4e 45 20 | Table }|.DEFINE |
|00000950| 6c 6f 6f 70 5f 76 61 72 | 09 09 7b 20 4c 6f 6f 70 |loop_var|..{ Loop|
|00000960| 20 69 74 65 72 61 74 69 | 6f 6e 20 63 6f 75 6e 74 | iterati|on count|
|00000970| 65 72 20 7d 0d 44 45 46 | 49 4e 45 20 64 6f 6e 65 |er }.DEF|INE done|
|00000980| 09 09 09 7b 20 41 72 65 | 20 77 65 20 64 6f 6e 65 |...{ Are| we done|
|00000990| 20 79 65 74 3f 20 7d 0d | 44 45 46 49 4e 45 20 74 | yet? }.|DEFINE t|
|000009a0| 69 6d 65 5f 6e 6f 77 5f | 72 6f 77 09 09 7b 20 54 |ime_now_|row..{ T|
|000009b0| 68 65 20 72 6f 77 20 6e | 75 6d 62 65 72 20 74 68 |he row n|umber th|
|000009c0| 61 74 20 72 65 70 72 65 | 73 65 6e 74 73 20 74 68 |at repre|sents th|
|000009d0| 65 20 63 75 72 72 65 6e | 74 20 74 69 6d 65 20 7d |e curren|t time }|
|000009e0| 0d 44 45 46 49 4e 45 20 | 6e 65 67 5f 66 6c 61 67 |.DEFINE |neg_flag|
|000009f0| 09 09 7b 20 4e 65 67 61 | 74 69 76 65 20 76 61 6c |..{ Nega|tive val|
|00000a00| 75 65 20 66 6c 61 67 20 | 7d 0d 0d 64 6f 6e 65 20 |ue flag |}..done |
|00000a10| 3d 20 30 09 09 09 09 7b | 20 53 65 74 20 64 6f 6e |= 0....{| Set don|
|00000a20| 65 20 74 6f 20 66 61 6c | 73 65 20 7d 0d 6e 65 67 |e to fal|se }.neg|
|00000a30| 5f 66 6c 61 67 20 3d 20 | 30 09 09 09 7b 20 53 65 |_flag = |0...{ Se|
|00000a40| 74 20 6e 65 67 5f 66 6c | 61 67 20 74 6f 20 66 61 |t neg_fl|ag to fa|
|00000a50| 6c 73 65 20 7d 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |lse }..{|********|
|00000a60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000a70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 4d 41 |********|***** MA|
|00000a80| 49 4e 20 53 43 52 49 50 | 54 20 2a 2a 2a 2a 2a 2a |IN SCRIP|T ******|
|00000a90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000aa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ab0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 52 |********|****}..R|
|00000ac0| 45 50 41 49 4e 54 20 4f | 46 46 09 09 09 09 09 7b |EPAINT O|FF.....{|
|00000ad0| 20 54 75 72 6e 20 52 65 | 70 61 69 6e 74 20 6f 66 | Turn Re|paint of|
|00000ae0| 66 20 74 6f 20 73 70 65 | 65 64 20 75 70 20 6f 70 |f to spe|ed up op|
|00000af0| 65 72 61 74 69 6f 6e 73 | 20 7d 0d 49 46 20 4d 41 |erations| }.IF MA|
|00000b00| 4b 45 5f 4e 45 57 5f 53 | 48 45 45 54 28 29 09 09 |KE_NEW_S|HEET()..|
|00000b10| 09 09 7b 20 43 72 65 61 | 74 65 20 61 20 6e 65 77 |..{ Crea|te a new|
|00000b20| 20 77 6f 72 6b 73 68 65 | 65 74 20 66 6f 72 20 66 | workshe|et for f|
|00000b30| 69 6e 61 6c 20 72 65 73 | 75 6c 74 73 20 7d 0d 09 |inal res|ults }..|
|00000b40| 43 41 4c 4c 20 46 4f 52 | 4d 41 54 5f 54 41 42 4c |CALL FOR|MAT_TABL|
|00000b50| 45 28 29 09 09 09 7b 20 | 43 61 6c 6c 20 74 68 65 |E()...{ |Call the|
|00000b60| 20 46 4f 52 4d 41 54 5f | 54 41 42 4c 45 20 66 75 | FORMAT_|TABLE fu|
|00000b70| 6e 63 74 69 6f 6e 20 7d | 0d 09 49 46 20 6c 61 73 |nction }|..IF las|
|00000b80| 74 5f 72 6f 77 20 3e 20 | 33 09 09 09 7b 20 49 46 |t_row > |3...{ IF|
|00000b90| 20 74 68 65 72 65 20 61 | 72 65 20 6d 6f 72 65 20 | there a|re more |
|00000ba0| 74 68 61 6e 20 33 20 72 | 6f 77 73 20 28 74 69 74 |than 3 r|ows (tit|
|00000bb0| 6c 65 2c 20 68 65 61 64 | 69 6e 67 73 2c 20 64 61 |le, head|ings, da|
|00000bc0| 74 61 29 2e 2e 2e 20 7d | 0d 09 09 43 41 4c 4c 20 |ta)... }|...CALL |
|00000bd0| 52 45 4d 4f 56 45 5f 44 | 41 54 45 53 28 29 09 09 |REMOVE_D|ATES()..|
|00000be0| 7b 20 43 61 6c 6c 20 74 | 68 65 20 52 45 4d 4f 56 |{ Call t|he REMOV|
|00000bf0| 45 5f 44 41 54 45 53 20 | 66 75 6e 63 74 69 6f 6e |E_DATES |function|
|00000c00| 20 7d 0d 09 09 43 41 4c | 4c 20 43 52 45 41 54 45 | }...CAL|L CREATE|
|00000c10| 5f 43 48 41 52 54 28 29 | 09 09 7b 20 43 61 6c 6c |_CHART()|..{ Call|
|00000c20| 20 74 68 65 20 43 52 45 | 41 54 45 5f 43 48 41 52 | the CRE|ATE_CHAR|
|00000c30| 54 20 66 75 6e 63 74 69 | 6f 6e 20 7d 0d 09 09 52 |T functi|on }...R|
|00000c40| 45 50 41 49 4e 54 20 4f | 4e 09 09 09 7b 20 54 75 |EPAINT O|N...{ Tu|
|00000c50| 72 6e 20 52 65 70 61 69 | 6e 74 20 6f 6e 20 74 6f |rn Repai|nt on to|
|00000c60| 20 73 68 6f 77 20 6f 75 | 72 20 63 68 61 72 74 20 | show ou|r chart |
|00000c70| 7d 0d 09 09 43 41 4c 4c | 20 41 53 4b 5f 54 4f 5f |}...CALL| ASK_TO_|
|00000c80| 43 4f 50 59 28 29 09 09 | 7b 20 43 61 6c 6c 20 74 |COPY()..|{ Call t|
|00000c90| 68 65 20 41 53 4b 5f 54 | 4f 5f 43 4f 50 59 20 66 |he ASK_T|O_COPY f|
|00000ca0| 75 6e 63 74 69 6f 6e 20 | 7d 0d 09 45 4c 53 45 09 |unction |}..ELSE.|
|00000cb0| 09 09 09 09 09 7b 20 4f | 74 68 65 72 77 69 73 65 |.....{ O|therwise|
|00000cc0| 20 7d 0d 09 09 4d 45 53 | 53 41 47 45 20 22 54 68 | }...MES|SAGE "Th|
|00000cd0| 65 72 65 20 69 73 20 6e | 6f 74 20 65 6e 6f 75 67 |ere is n|ot enoug|
|00000ce0| 68 20 43 61 73 68 20 46 | 6c 6f 77 20 64 61 74 61 |h Cash F|low data|
|00000cf0| 20 74 6f 20 63 72 65 61 | 74 65 20 61 20 67 72 61 | to crea|te a gra|
|00000d00| 70 68 2e 22 20 0d 09 09 | 43 4c 4f 53 45 20 4e 4f |ph." ...|CLOSE NO|
|00000d10| 57 09 09 09 09 7b 20 43 | 6c 6f 73 65 20 43 61 73 |W....{ C|lose Cas|
|00000d20| 68 20 46 6c 6f 77 20 54 | 61 62 6c 65 20 77 69 74 |h Flow T|able wit|
|00000d30| 68 6f 75 74 20 73 61 76 | 69 6e 67 20 7d 0d 09 45 |hout sav|ing }..E|
|00000d40| 4e 44 20 49 46 0d 45 4e | 44 20 49 46 0d 0d 7b 2a |ND IF.EN|D IF..{*|
|00000d50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d70| 2a 2a 20 4d 41 4b 45 5f | 4e 45 57 5f 53 48 45 45 |** MAKE_|NEW_SHEE|
|00000d80| 54 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T ******|********|
|00000d90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000da0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000db0| 2a 2a 2a 0d 20 20 54 68 | 69 73 20 66 75 6e 63 74 |***.  Th|is funct|
|00000dc0| 69 6f 6e 20 63 72 65 61 | 74 65 73 20 61 20 6e 65 |ion crea|tes a ne|
|00000dd0| 77 20 77 6f 72 6b 73 68 | 65 65 74 20 69 6e 20 77 |w worksh|eet in w|
|00000de0| 68 69 63 68 20 74 68 65 | 20 66 69 6e 61 6c 20 73 |hich the| final s|
|00000df0| 63 72 69 70 74 20 72 65 | 73 75 6c 74 73 20 77 69 |cript re|sults wi|
|00000e00| 6c 6c 20 62 65 20 64 69 | 73 70 6c 61 79 65 64 2e |ll be di|splayed.|
|00000e10| 0d 20 20 54 68 69 73 20 | 73 74 65 70 20 69 73 20 |.  This |step is |
|00000e20| 6e 65 63 65 73 73 61 72 | 79 20 73 6f 20 74 68 61 |necessar|y so tha|
|00000e30| 74 20 74 68 65 20 66 69 | 6e 61 6c 20 77 6f 72 6b |t the fi|nal work|
|00000e40| 73 68 65 65 74 20 6d 61 | 79 20 62 65 20 6c 65 66 |sheet ma|y be lef|
|00000e50| 74 20 6f 70 65 6e 20 77 | 68 65 6e 20 72 65 2d 65 |t open w|hen re-e|
|00000e60| 78 65 63 75 74 69 6e 67 | 0d 20 20 74 68 65 20 73 |xecuting|.  the s|
|00000e70| 61 6d 65 20 45 78 63 68 | 61 6e 67 65 20 69 74 65 |ame Exch|ange ite|
|00000e80| 6d 20 28 6f 72 20 61 6e | 6f 74 68 65 72 20 77 68 |m (or an|other wh|
|00000e90| 69 63 68 20 75 73 65 73 | 20 74 68 65 20 73 61 6d |ich uses| the sam|
|00000ea0| 65 20 65 78 70 6f 72 74 | 20 64 6f 63 75 6d 65 6e |e export| documen|
|00000eb0| 74 29 20 77 69 74 68 6f | 75 74 20 63 61 75 73 69 |t) witho|ut causi|
|00000ec0| 6e 67 0d 20 20 61 20 63 | 6f 6e 66 6c 69 63 74 20 |ng.  a c|onflict |
|00000ed0| 6f 66 20 77 6f 72 6b 73 | 68 65 65 74 20 6e 61 6d |of works|heet nam|
|00000ee0| 65 73 2e 0d 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |es.. ***|********|
|00000ef0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 46 55 4e 43 |********|*}..FUNC|
|00000f50| 54 49 4f 4e 20 4d 41 4b | 45 5f 4e 45 57 5f 53 48 |TION MAK|E_NEW_SH|
|00000f60| 45 45 54 28 29 0d 09 4e | 45 57 20 57 4f 52 4b 53 |EET()..N|EW WORKS|
|00000f70| 48 45 45 54 20 22 22 09 | 09 09 09 7b 20 43 72 65 |HEET "".|...{ Cre|
|00000f80| 61 74 65 20 61 20 6e 65 | 77 20 75 6e 74 69 74 6c |ate a ne|w untitl|
|00000f90| 65 64 20 77 6f 72 6b 73 | 68 65 65 74 20 7d 0d 09 |ed works|heet }..|
|00000fa0| 53 45 4c 45 43 54 20 52 | 41 4e 47 45 20 41 31 09 |SELECT R|ANGE A1.|
|00000fb0| 09 09 09 7b 20 4d 61 6b | 65 20 73 75 72 65 20 74 |...{ Mak|e sure t|
|00000fc0| 68 65 20 6e 65 78 74 20 | 6c 69 6e 65 20 70 75 74 |he next |line put|
|00000fd0| 73 20 74 68 65 20 69 6e | 66 6f 20 69 6e 20 74 68 |s the in|fo in th|
|00000fe0| 65 20 63 6f 72 72 65 63 | 74 20 6c 6f 63 61 74 69 |e correc|t locati|
|00000ff0| 6f 6e 20 7d 0d 09 41 50 | 50 45 4e 44 20 22 4d 50 |on }..AP|PEND "MP|
|00001000| 20 43 61 73 68 20 46 6c | 6f 77 20 54 61 62 6c 65 | Cash Fl|ow Table|
|00001010| 22 09 09 7b 20 41 70 70 | 65 6e 64 20 4d 61 63 50 |"..{ App|end MacP|
|00001020| 72 6f 6a 65 63 74 20 43 | 61 73 68 20 46 6c 6f 77 |roject C|ash Flow|
|00001030| 20 65 78 70 6f 72 74 20 | 66 69 6c 65 20 7d 0d 09 | export |file }..|
|00001040| 49 46 20 43 45 52 52 4f | 52 28 29 20 3d 20 30 09 |IF CERRO|R() = 0.|
|00001050| 09 09 09 7b 20 57 61 73 | 20 74 68 65 20 43 61 73 |...{ Was| the Cas|
|00001060| 68 20 46 6c 6f 77 20 64 | 6f 63 75 6d 65 6e 74 20 |h Flow d|ocument |
|00001070| 66 6f 75 6e 64 3f 20 7d | 0d 09 09 5a 4f 4f 4d 20 |found? }|...ZOOM |
|00001080| 57 49 4e 44 4f 57 09 09 | 09 09 7b 20 4d 61 6b 65 |WINDOW..|..{ Make|
|00001090| 20 73 75 72 65 20 77 69 | 6e 64 6f 77 20 66 69 6c | sure wi|ndow fil|
|000010a0| 6c 73 20 74 68 65 20 73 | 63 72 65 65 6e 20 7d 0d |ls the s|creen }.|
|000010b0| 09 09 52 45 54 55 52 4e | 20 31 09 09 09 09 09 7b |..RETURN| 1.....{|
|000010c0| 20 52 65 74 75 72 6e 20 | 61 20 76 61 6c 75 65 20 | Return |a value |
|000010d0| 69 6e 64 69 63 61 74 69 | 6e 67 20 74 68 65 20 73 |indicati|ng the s|
|000010e0| 63 72 69 70 74 20 73 68 | 6f 75 6c 64 20 63 6f 6e |cript sh|ould con|
|000010f0| 74 69 6e 75 65 20 7d 0d | 09 45 4c 53 45 0d 09 09 |tinue }.|.ELSE...|
|00001100| 52 45 54 55 52 4e 20 30 | 09 09 09 09 09 7b 20 52 |RETURN 0|.....{ R|
|00001110| 65 74 75 72 6e 20 61 20 | 76 61 6c 75 65 20 69 6e |eturn a |value in|
|00001120| 64 69 63 61 74 69 6e 67 | 20 74 68 65 20 73 63 72 |dicating| the scr|
|00001130| 69 70 74 20 73 68 6f 75 | 6c 64 20 62 65 20 73 74 |ipt shou|ld be st|
|00001140| 6f 70 70 65 64 20 7d 0d | 09 45 4e 44 20 49 46 0d |opped }.|.END IF.|
|00001150| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|00001160| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001170| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001180| 2a 2a 2a 2a 20 46 4f 52 | 4d 41 54 5f 54 41 42 4c |**** FOR|MAT_TABL|
|00001190| 45 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |E ******|********|
|000011a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000011b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000011c0| 2a 2a 2a 2a 0d 20 20 54 | 68 69 73 20 66 75 6e 63 |****.  T|his func|
|000011d0| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 65 73 20 74 |tion spe|cifies t|
|000011e0| 68 65 20 74 65 78 74 20 | 61 6e 64 20 63 65 6c 6c |he text |and cell|
|000011f0| 20 61 74 74 72 69 62 75 | 74 65 73 20 6e 65 65 64 | attribu|tes need|
|00001200| 65 64 20 62 79 20 6f 75 | 72 20 63 68 61 72 74 2e |ed by ou|r chart.|
|00001210| 20 20 54 68 65 20 63 68 | 61 72 74 20 61 74 74 72 |  The ch|art attr|
|00001220| 69 62 75 74 65 73 20 61 | 72 65 0d 20 20 64 65 74 |ibutes a|re.  det|
|00001230| 65 72 6d 69 6e 65 64 20 | 62 79 20 74 68 65 20 61 |ermined |by the a|
|00001240| 74 74 72 69 62 75 74 65 | 73 20 6f 66 20 74 68 6f |ttribute|s of tho|
|00001250| 73 65 20 63 65 6c 6c 73 | 20 66 72 6f 6d 20 77 68 |se cells| from wh|
|00001260| 69 63 68 20 69 74 73 20 | 64 61 74 61 20 69 73 20 |ich its |data is |
|00001270| 64 65 72 69 76 65 64 2e | 0d 20 2a 2a 2a 2a 2a 2a |derived.|. ******|
|00001280| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001290| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|000012e0| 0d 46 55 4e 43 54 49 4f | 4e 20 46 4f 52 4d 41 54 |.FUNCTIO|N FORMAT|
|000012f0| 5f 54 41 42 4c 45 28 29 | 0d 09 5a 4f 4f 4d 20 57 |_TABLE()|..ZOOM W|
|00001300| 49 4e 44 4f 57 09 09 09 | 09 09 09 7b 20 5a 6f 6f |INDOW...|...{ Zoo|
|00001310| 6d 20 74 68 65 20 77 69 | 6e 64 6f 77 20 74 6f 20 |m the wi|ndow to |
|00001320| 65 6e 73 75 72 65 20 74 | 68 61 74 20 69 74 20 66 |ensure t|hat it f|
|00001330| 69 6c 6c 73 20 74 68 65 | 20 73 63 72 65 65 6e 20 |ills the| screen |
|00001340| 7d 0d 09 48 49 44 45 20 | 48 45 41 44 49 4e 47 53 |}..HIDE |HEADINGS|
|00001350| 09 09 09 09 09 09 7b 20 | 48 69 64 65 20 74 68 65 |......{ |Hide the|
|00001360| 20 72 6f 77 20 61 6e 64 | 20 63 6f 6c 75 6d 6e 20 | row and| column |
|00001370| 68 65 61 64 69 6e 67 73 | 20 7d 0d 09 48 49 44 45 |headings| }..HIDE|
|00001380| 20 54 4f 4f 4c 20 42 4f | 58 09 09 09 09 09 09 7b | TOOL BO|X......{|
|00001390| 20 48 69 64 65 20 74 68 | 65 20 74 6f 6f 6c 20 70 | Hide th|e tool p|
|000013a0| 61 6c 65 74 74 65 20 61 | 74 20 74 68 65 20 6c 65 |alette a|t the le|
|000013b0| 66 74 20 65 64 67 65 20 | 6f 66 20 74 68 65 20 77 |ft edge |of the w|
|000013c0| 69 6e 64 6f 77 20 7d 0d | 09 48 49 44 45 20 45 4e |indow }.|.HIDE EN|
|000013d0| 54 52 59 20 42 41 52 09 | 09 09 09 09 09 7b 20 48 |TRY BAR.|.....{ H|
|000013e0| 69 64 65 20 74 68 65 20 | 65 6e 74 72 79 20 62 61 |ide the |entry ba|
|000013f0| 72 20 61 74 20 74 68 65 | 20 74 6f 70 20 6f 66 20 |r at the| top of |
|00001400| 74 68 65 20 77 69 6e 64 | 6f 77 20 7d 0d 09 48 49 |the wind|ow }..HI|
|00001410| 44 45 20 43 45 4c 4c 20 | 47 52 49 44 09 09 09 09 |DE CELL |GRID....|
|00001420| 09 09 7b 20 48 69 64 65 | 20 74 68 65 20 63 65 6c |..{ Hide| the cel|
|00001430| 6c 20 67 72 69 64 20 7d | 0d 09 53 45 4c 45 43 54 |l grid }|..SELECT|
|00001440| 20 52 41 4e 47 45 20 41 | 31 2e 2e 41 56 4c 48 31 | RANGE A|1..AVLH1|
|00001450| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 74 68 65 |....{ Se|lect the|
|00001460| 20 66 69 72 73 74 20 72 | 6f 77 20 6f 66 20 74 68 | first r|ow of th|
|00001470| 65 20 74 61 62 6c 65 20 | 7d 0d 09 49 4e 53 45 52 |e table |}..INSER|
|00001480| 54 09 09 09 09 09 09 09 | 7b 20 49 6e 73 65 72 74 |T.......|{ Insert|
|00001490| 20 61 20 72 6f 77 20 66 | 6f 72 20 6e 61 6d 65 73 | a row f|or names|
|000014a0| 20 69 6e 20 74 68 65 20 | 43 61 73 68 20 46 6c 6f | in the |Cash Flo|
|000014b0| 77 20 43 68 61 72 74 2e | 20 7d 0d 09 49 4e 53 45 |w Chart.| }..INSE|
|000014c0| 52 54 09 09 09 09 09 09 | 09 7b 20 49 6e 73 65 72 |RT......|.{ Inser|
|000014d0| 74 20 61 20 72 6f 77 20 | 61 62 6f 76 65 20 6e 61 |t a row |above na|
|000014e0| 6d 65 73 20 66 6f 72 20 | 6c 6f 6f 6b 73 20 7d 0d |mes for |looks }.|
|000014f0| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 41 31 |.SELECT |RANGE A1|
|00001500| 2e 2e 41 33 32 37 36 37 | 09 09 09 09 7b 20 53 65 |..A32767|....{ Se|
|00001510| 6c 65 63 74 20 74 68 65 | 20 66 69 72 73 74 20 63 |lect the| first c|
|00001520| 6f 6c 75 6d 6e 20 6f 66 | 20 74 68 65 20 74 61 62 |olumn of| the tab|
|00001530| 6c 65 20 7d 0d 09 49 4e | 53 45 52 54 09 09 09 09 |le }..IN|SERT....|
|00001540| 09 09 09 7b 20 49 6e 73 | 65 72 74 20 61 6e 20 65 |...{ Ins|ert an e|
|00001550| 6d 70 74 79 20 63 6f 6c | 75 6d 6e 20 66 6f 72 20 |mpty col|umn for |
|00001560| 6c 6f 6f 6b 73 20 7d 0d | 09 6c 61 73 74 5f 72 6f |looks }.|.last_ro|
|00001570| 77 20 3d 20 47 45 54 5f | 52 4f 57 53 28 29 09 09 |w = GET_|ROWS()..|
|00001580| 09 09 7b 20 44 65 74 65 | 72 6d 69 6e 65 20 74 68 |..{ Dete|rmine th|
|00001590| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |e number| of rows|
|000015a0| 20 69 6e 20 74 68 65 20 | 74 61 62 6c 65 20 7d 0d | in the |table }.|
|000015b0| 09 54 45 58 54 20 46 4f | 4e 54 20 22 48 65 6c 76 |.TEXT FO|NT "Helv|
|000015c0| 65 74 69 63 61 22 09 09 | 09 09 7b 20 53 65 74 20 |etica"..|..{ Set |
|000015d0| 74 68 65 20 66 6f 6e 74 | 20 74 6f 20 48 65 6c 76 |the font| to Helv|
|000015e0| 65 74 69 63 61 20 7d 0d | 09 43 4f 4c 55 4d 4e 20 |etica }.|.COLUMN |
|000015f0| 57 49 44 54 48 20 28 31 | 2e 35 20 49 4e 43 48 45 |WIDTH (1|.5 INCHE|
|00001600| 53 20 29 09 09 09 7b 20 | 53 65 74 20 74 68 65 20 |S )...{ |Set the |
|00001610| 63 6f 6c 75 6d 6e 20 77 | 69 64 74 68 20 66 6f 72 |column w|idth for|
|00001620| 20 74 68 65 20 64 61 74 | 61 20 7d 0d 09 50 55 54 | the dat|a }..PUT|
|00001630| 20 22 53 74 61 72 74 69 | 6e 67 22 20 49 4e 54 4f | "Starti|ng" INTO|
|00001640| 20 42 32 09 09 09 09 7b | 20 41 64 64 20 74 68 65 | B2....{| Add the|
|00001650| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|00001660| 7d 0d 09 50 55 54 20 22 | 50 6c 61 6e 20 43 6f 73 |}..PUT "|Plan Cos|
|00001670| 74 73 22 20 49 4e 54 4f | 20 43 32 09 09 09 09 7b |ts" INTO| C2....{|
|00001680| 20 41 64 64 20 74 68 65 | 20 63 6f 6c 75 6d 6e 20 | Add the| column |
|00001690| 68 65 61 64 69 6e 67 20 | 7d 0d 09 50 55 54 20 22 |heading |}..PUT "|
|000016a0| 50 6c 61 6e 20 49 6e 63 | 6f 6d 65 22 20 49 4e 54 |Plan Inc|ome" INT|
|000016b0| 4f 20 44 32 09 09 09 7b | 20 41 64 64 20 74 68 65 |O D2...{| Add the|
|000016c0| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|000016d0| 7d 0d 09 50 55 54 20 22 | 41 63 74 75 61 6c 20 43 |}..PUT "|Actual C|
|000016e0| 6f 73 74 73 22 20 49 4e | 54 4f 20 45 32 09 09 09 |osts" IN|TO E2...|
|000016f0| 7b 20 41 64 64 20 74 68 | 65 20 63 6f 6c 75 6d 6e |{ Add th|e column|
|00001700| 20 68 65 61 64 69 6e 67 | 20 7d 0d 09 50 55 54 20 | heading| }..PUT |
|00001710| 22 41 63 74 75 61 6c 20 | 49 6e 63 6f 6d 65 22 20 |"Actual |Income" |
|00001720| 49 4e 54 4f 20 46 32 09 | 09 09 7b 20 41 64 64 20 |INTO F2.|..{ Add |
|00001730| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 68 65 61 64 69 |the colu|mn headi|
|00001740| 6e 67 20 7d 0d 09 50 55 | 54 20 22 45 6e 64 69 6e |ng }..PU|T "Endin|
|00001750| 67 22 20 49 4e 54 4f 20 | 47 32 20 20 09 09 09 09 |g" INTO |G2  ....|
|00001760| 7b 20 41 64 64 20 74 68 | 65 20 63 6f 6c 75 6d 6e |{ Add th|e column|
|00001770| 20 68 65 61 64 69 6e 67 | 20 7d 0d 09 50 55 54 20 | heading| }..PUT |
|00001780| 22 50 6c 61 6e 22 20 49 | 4e 54 4f 20 48 32 09 09 |"Plan" I|NTO H2..|
|00001790| 09 09 09 7b 20 41 64 64 | 20 74 68 65 20 63 6f 6c |...{ Add| the col|
|000017a0| 75 6d 6e 20 68 65 61 64 | 69 6e 67 20 7d 0d 09 50 |umn head|ing }..P|
|000017b0| 55 54 20 22 41 63 74 75 | 61 6c 22 20 49 4e 54 4f |UT "Actu|al" INTO|
|000017c0| 20 49 32 09 09 09 09 7b | 20 41 64 64 20 74 68 65 | I2....{| Add the|
|000017d0| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|000017e0| 7d 0d 09 50 55 54 20 22 | 43 61 73 68 20 46 6c 6f |}..PUT "|Cash Flo|
|000017f0| 77 20 2d 20 22 20 09 09 | 09 09 09 7b 20 49 6e 73 |w - " ..|...{ Ins|
|00001800| 65 72 74 20 63 68 61 72 | 74 20 74 69 74 6c 65 20 |ert char|t title |
|00001810| 61 6e 64 2e 2e 2e 20 7d | 0d 09 09 26 41 44 41 54 |and... }|...&ADAT|
|00001820| 45 28 4e 4f 57 28 29 3b | 22 6d 6d 2f 64 64 2f 79 |E(NOW();|"mm/dd/y|
|00001830| 79 22 29 20 49 4e 54 4f | 20 47 31 20 20 09 7b 20 |y") INTO| G1  .{ |
|00001840| 2e 2e 2e 64 61 74 65 20 | 69 6e 74 6f 20 63 65 6c |...date |into cel|
|00001850| 6c 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |l }..SEL|ECT RANG|
|00001860| 45 20 42 31 2e 2e 49 32 | 09 09 09 09 09 7b 20 53 |E B1..I2|.....{ S|
|00001870| 65 6c 65 63 74 20 74 68 | 65 20 63 65 6c 6c 73 20 |elect th|e cells |
|00001880| 63 6f 6e 74 61 69 6e 69 | 6e 67 20 74 69 74 6c 65 |containi|ng title|
|00001890| 73 20 7d 0d 09 54 45 58 | 54 20 53 49 5a 45 20 31 |s }..TEX|T SIZE 1|
|000018a0| 34 09 09 09 09 09 09 7b | 20 53 70 65 63 69 66 79 |4......{| Specify|
|000018b0| 20 74 68 65 20 73 69 7a | 65 20 6f 66 20 74 68 65 | the siz|e of the|
|000018c0| 20 74 69 74 6c 65 20 74 | 65 78 74 20 7d 0d 09 54 | title t|ext }..T|
|000018d0| 45 58 54 20 53 54 59 4c | 45 20 22 42 22 09 09 09 |EXT STYL|E "B"...|
|000018e0| 09 09 09 7b 20 4d 61 6b | 65 20 74 68 65 20 66 6f |...{ Mak|e the fo|
|000018f0| 6e 74 20 62 6f 6c 64 20 | 7d 0d 09 54 45 58 54 20 |nt bold |}..TEXT |
|00001900| 53 54 59 4c 45 20 22 49 | 22 09 09 09 09 09 09 7b |STYLE "I|"......{|
|00001910| 20 4d 61 6b 65 20 74 68 | 65 20 66 6f 6e 74 20 69 | Make th|e font i|
|00001920| 74 61 6c 69 63 20 7d 0d | 09 53 45 4c 45 43 54 20 |talic }.|.SELECT |
|00001930| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|00001940| 33 3b 33 3b 36 3b 6c 61 | 73 74 5f 72 6f 77 29 29 |3;3;6;la|st_row))|
|00001950| 20 7b 20 53 65 6c 65 63 | 74 20 63 6f 6c 75 6d 6e | { Selec|t column|
|00001960| 73 20 33 20 74 68 72 6f | 75 67 68 20 36 20 7d 0d |s 3 thro|ugh 6 }.|
|00001970| 09 46 4f 52 4d 41 54 20 | 43 55 52 52 45 4e 43 59 |.FORMAT |CURRENCY|
|00001980| 09 09 09 09 09 7b 20 43 | 68 61 6e 67 65 20 74 6f |.....{ C|hange to|
|00001990| 20 63 75 72 72 65 6e 63 | 79 20 66 6f 72 6d 61 74 | currenc|y format|
|000019a0| 20 7d 0d 09 55 53 45 20 | 43 4f 4d 4d 41 53 09 09 | }..USE |COMMAS..|
|000019b0| 09 09 09 09 7b 20 55 73 | 65 20 63 6f 6d 6d 61 73 |....{ Us|e commas|
|000019c0| 20 69 6e 20 74 68 65 20 | 64 6f 6c 6c 61 72 20 66 | in the |dollar f|
|000019d0| 6f 72 6d 61 74 20 7d 0d | 09 53 45 4c 45 43 54 20 |ormat }.|.SELECT |
|000019e0| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|000019f0| 37 3b 33 3b 37 3b 6c 61 | 73 74 5f 72 6f 77 29 29 |7;3;7;la|st_row))|
|00001a00| 09 7b 20 53 65 6c 65 63 | 74 20 63 6f 6c 75 6d 6e |.{ Selec|t column|
|00001a10| 20 37 20 7d 0d 09 46 4f | 52 4d 41 54 20 44 41 54 | 7 }..FO|RMAT DAT|
|00001a20| 45 20 31 09 09 09 09 09 | 09 7b 20 43 68 61 6e 67 |E 1.....|.{ Chang|
|00001a30| 65 20 74 68 65 20 64 61 | 74 65 20 66 6f 72 6d 61 |e the da|te forma|
|00001a40| 74 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |t }..SEL|ECT RANG|
|00001a50| 45 28 4d 41 4b 45 52 41 | 4e 47 45 28 38 3b 33 3b |E(MAKERA|NGE(8;3;|
|00001a60| 39 3b 6c 61 73 74 5f 72 | 6f 77 29 29 20 7b 20 53 |9;last_r|ow)) { S|
|00001a70| 65 6c 65 63 74 20 63 6f | 6c 75 6d 6e 73 20 38 20 |elect co|lumns 8 |
|00001a80| 74 68 72 6f 75 67 68 20 | 31 30 20 7d 0d 09 46 4f |through |10 }..FO|
|00001a90| 52 4d 41 54 20 43 55 52 | 52 45 4e 43 59 09 09 09 |RMAT CUR|RENCY...|
|00001aa0| 09 09 7b 20 43 68 61 6e | 67 65 20 74 6f 20 63 75 |..{ Chan|ge to cu|
|00001ab0| 72 72 65 6e 63 79 20 66 | 6f 72 6d 61 74 20 7d 0d |rrency f|ormat }.|
|00001ac0| 09 55 53 45 20 43 4f 4d | 4d 41 53 09 09 09 09 09 |.USE COM|MAS.....|
|00001ad0| 09 7b 20 55 73 65 20 63 | 6f 6d 6d 61 73 20 69 6e |.{ Use c|ommas in|
|00001ae0| 20 74 68 65 20 64 6f 6c | 6c 61 72 20 66 6f 72 6d | the dol|lar form|
|00001af0| 61 74 20 7d 0d 09 53 45 | 4c 45 43 54 20 52 41 4e |at }..SE|LECT RAN|
|00001b00| 47 45 28 4d 41 4b 45 52 | 41 4e 47 45 28 32 3b 32 |GE(MAKER|ANGE(2;2|
|00001b10| 3b 39 3b 6c 61 73 74 5f | 72 6f 77 29 29 20 7b 20 |;9;last_|row)) { |
|00001b20| 53 65 6c 65 63 74 20 65 | 6e 74 69 72 65 20 74 61 |Select e|ntire ta|
|00001b30| 62 6c 65 20 7d 0d 09 43 | 45 4c 4c 20 42 4f 52 44 |ble }..C|ELL BORD|
|00001b40| 45 52 20 22 54 4c 42 52 | 22 09 09 09 09 09 7b 20 |ER "TLBR|".....{ |
|00001b50| 50 75 74 20 62 6f 72 64 | 65 72 20 61 72 6f 75 6e |Put bord|er aroun|
|00001b60| 64 20 65 61 63 68 20 63 | 65 6c 6c 20 7d 0d 45 4e |d each c|ell }.EN|
|00001b70| 44 20 46 55 4e 43 54 49 | 4f 4e 0d 0d 7b 2a 2a 2a |D FUNCTI|ON..{***|
|00001b80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ba0| 2a 2a 20 52 45 4d 4f 56 | 45 5f 44 41 54 45 53 20 |** REMOV|E_DATES |
|00001bb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001bc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001bd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001be0| 2a 2a 0d 20 20 54 68 69 | 73 20 66 75 6e 63 74 69 |**.  Thi|s functi|
|00001bf0| 6f 6e 20 65 6c 69 6d 69 | 6e 61 74 65 73 20 73 6f |on elimi|nates so|
|00001c00| 6d 65 20 6f 66 20 74 68 | 65 20 64 61 74 65 73 20 |me of th|e dates |
|00001c10| 74 6f 20 72 65 64 75 63 | 65 20 63 72 6f 77 64 69 |to reduc|e crowdi|
|00001c20| 6e 67 20 6f 6e 20 78 20 | 61 78 69 73 2e 0d 20 2a |ng on x |axis.. *|
|00001c30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c90| 2a 2a 2a 7d 0d 09 0d 46 | 55 4e 43 54 49 4f 4e 20 |***}...F|UNCTION |
|00001ca0| 52 45 4d 4f 56 45 5f 44 | 41 54 45 53 28 29 0d 09 |REMOVE_D|ATES()..|
|00001cb0| 44 45 46 49 4e 45 20 6f | 75 74 65 72 5f 6c 6f 6f |DEFINE o|uter_loo|
|00001cc0| 70 09 09 09 09 09 09 7b | 20 4f 75 74 65 72 20 6c |p......{| Outer l|
|00001cd0| 6f 6f 70 20 63 6f 75 6e | 74 65 72 20 7d 0d 09 44 |oop coun|ter }..D|
|00001ce0| 45 46 49 4e 45 20 65 6e | 64 5f 6c 6f 6f 70 09 09 |EFINE en|d_loop..|
|00001cf0| 09 09 09 09 7b 20 45 6e | 64 20 6f 66 20 6c 6f 6f |....{ En|d of loo|
|00001d00| 70 20 63 6f 75 6e 74 65 | 72 7d 0d 09 0d 09 49 46 |p counte|r}....IF|
|00001d10| 20 6c 61 73 74 5f 72 6f | 77 20 3e 20 31 31 09 09 | last_ro|w > 11..|
|00001d20| 09 09 09 09 7b 20 43 68 | 65 63 6b 20 66 6f 72 20 |....{ Ch|eck for |
|00001d30| 6d 69 6e 69 6d 75 6d 20 | 23 20 6f 66 20 72 6f 77 |minimum |# of row|
|00001d40| 73 20 7d 0d 09 09 65 6e | 64 5f 6c 6f 6f 70 20 3d |s }...en|d_loop =|
|00001d50| 20 49 4e 54 28 28 6c 61 | 73 74 5f 72 6f 77 2d 31 | INT((la|st_row-1|
|00001d60| 29 2f 39 29 09 09 7b 20 | 43 61 6c 63 75 6c 61 74 |)/9)..{ |Calculat|
|00001d70| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 63 65 6c 6c |e number| of cell|
|00001d80| 73 20 74 6f 20 63 6c 65 | 61 72 20 7d 0d 09 09 46 |s to cle|ar }...F|
|00001d90| 4f 52 20 6f 75 74 65 72 | 5f 6c 6f 6f 70 20 3d 20 |OR outer|_loop = |
|00001da0| 32 20 74 6f 20 65 6e 64 | 5f 6c 6f 6f 70 09 09 7b |2 to end|_loop..{|
|00001db0| 20 42 65 67 69 6e 20 6f | 75 74 65 72 20 6c 6f 6f | Begin o|uter loo|
|00001dc0| 70 20 7d 0d 09 09 09 46 | 4f 52 20 6c 6f 6f 70 5f |p }....F|OR loop_|
|00001dd0| 76 61 72 20 3d 20 6f 75 | 74 65 72 5f 6c 6f 6f 70 |var = ou|ter_loop|
|00001de0| 2b 31 20 09 09 7b 20 53 | 74 61 72 74 69 6e 67 20 |+1 ..{ S|tarting |
|00001df0| 61 74 20 72 6f 77 20 6f | 75 74 65 72 5f 6c 6f 6f |at row o|uter_loo|
|00001e00| 70 2b 31 2e 2e 2e 20 7d | 0d 09 09 09 09 54 4f 20 |p+1... }|.....TO |
|00001e10| 6c 61 73 74 5f 72 6f 77 | 20 53 54 45 50 20 65 6e |last_row| STEP en|
|00001e20| 64 5f 6c 6f 6f 70 20 09 | 7b 20 2e 2e 2e 73 74 65 |d_loop .|{ ...ste|
|00001e30| 70 20 74 68 72 6f 75 67 | 68 20 65 76 65 72 79 20 |p throug|h every |
|00001e40| 65 6e 64 5f 6c 6f 6f 70 | 74 68 20 72 6f 77 20 7d |end_loop|th row }|
|00001e50| 0d 20 09 09 09 09 50 55 | 54 20 22 20 22 20 49 4e |. ....PU|T " " IN|
|00001e60| 54 4f 20 4d 41 4b 45 43 | 45 4c 4c 28 37 3b 20 6c |TO MAKEC|ELL(7; l|
|00001e70| 6f 6f 70 5f 76 61 72 29 | 09 7b 20 50 75 74 20 61 |oop_var)|.{ Put a|
|00001e80| 20 62 6c 61 6e 6b 20 69 | 6e 74 6f 20 74 68 65 20 | blank i|nto the |
|00001e90| 63 65 6c 6c 20 7d 0d 09 | 09 09 45 4e 44 20 46 4f |cell }..|..END FO|
|00001ea0| 52 09 09 09 09 09 09 7b | 20 45 6e 64 20 46 4f 52 |R......{| End FOR|
|00001eb0| 20 6c 6f 6f 70 20 7d 0d | 09 09 45 4e 44 20 46 4f | loop }.|..END FO|
|00001ec0| 52 09 09 09 09 09 09 09 | 7b 20 45 6e 64 20 46 4f |R.......|{ End FO|
|00001ed0| 52 20 6c 6f 6f 70 20 7d | 0d 09 45 4e 44 20 49 46 |R loop }|..END IF|
|00001ee0| 09 09 09 09 09 09 09 09 | 7b 20 45 6e 64 20 6c 6f |........|{ End lo|
|00001ef0| 67 69 63 61 6c 20 49 46 | 20 7d 0d 45 4e 44 20 46 |gical IF| }.END F|
|00001f00| 55 4e 43 54 49 4f 4e 0d | 0d 7b 2a 2a 2a 2a 2a 2a |UNCTION.|.{******|
|00001f10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001f20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00001f30| 47 45 54 5f 52 4f 57 53 | 20 2a 2a 2a 2a 2a 2a 2a |GET_ROWS| *******|
|00001f40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001f50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001f60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00001f70| 20 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |  This f|unction |
|00001f80| 64 65 74 65 72 6d 69 6e | 65 73 20 74 68 65 20 6e |determin|es the n|
|00001f90| 75 6d 62 65 72 20 6f 66 | 20 72 6f 77 73 20 75 73 |umber of| rows us|
|00001fa0| 65 64 20 6f 6e 20 61 20 | 63 68 61 72 74 2e 20 20 |ed on a |chart.  |
|00001fb0| 57 65 20 66 69 72 73 74 | 20 73 65 6c 65 63 74 20 |We first| select |
|00001fc0| 61 6c 6c 20 61 63 74 69 | 76 65 20 63 65 6c 6c 73 |all acti|ve cells|
|00001fd0| 2e 0d 20 20 57 65 20 74 | 68 65 6e 20 75 73 65 20 |..  We t|hen use |
|00001fe0| 74 68 65 20 53 45 4c 45 | 43 54 49 4f 4e 20 66 75 |the SELE|CTION fu|
|00001ff0| 6e 63 74 69 6f 6e 20 74 | 6f 20 72 65 74 75 72 6e |nction t|o return|
|00002000| 20 74 68 65 20 72 61 6e | 67 65 20 61 6e 64 20 74 | the ran|ge and t|
|00002010| 68 65 20 52 4f 57 53 20 | 66 75 6e 63 74 69 6f 6e |he ROWS |function|
|00002020| 20 74 6f 20 67 65 74 20 | 74 68 65 20 6e 75 6d 62 | to get |the numb|
|00002030| 65 72 20 6f 66 0d 20 20 | 72 6f 77 73 20 69 6e 20 |er of.  |rows in |
|00002040| 74 68 61 74 20 72 61 6e | 67 65 2e 20 20 54 68 65 |that ran|ge.  The|
|00002050| 20 72 65 73 75 6c 74 69 | 6e 67 20 76 61 6c 75 65 | resulti|ng value|
|00002060| 20 69 73 20 74 68 65 6e | 20 72 65 74 75 72 6e 65 | is then| returne|
|00002070| 64 20 74 6f 20 74 68 65 | 20 63 61 6c 6c 69 6e 67 |d to the| calling|
|00002080| 20 73 74 61 74 65 6d 65 | 6e 74 2e 0d 20 2a 2a 2a | stateme|nt.. ***|
|00002090| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020f0| 2a 7d 0d 0d 46 55 4e 43 | 54 49 4f 4e 20 47 45 54 |*}..FUNC|TION GET|
|00002100| 5f 52 4f 57 53 28 29 0d | 09 53 45 4c 45 43 54 20 |_ROWS().|.SELECT |
|00002110| 41 43 54 49 56 45 20 43 | 45 4c 4c 53 09 09 09 09 |ACTIVE C|ELLS....|
|00002120| 09 09 7b 20 53 65 6c 65 | 63 74 20 6e 6f 6e 2d 62 |..{ Sele|ct non-b|
|00002130| 6c 61 6e 6b 20 63 65 6c | 6c 73 20 7d 0d 09 52 45 |lank cel|ls }..RE|
|00002140| 54 55 52 4e 20 52 4f 57 | 53 28 53 45 4c 45 43 54 |TURN ROW|S(SELECT|
|00002150| 49 4f 4e 28 31 29 29 09 | 09 09 09 7b 20 44 65 74 |ION(1)).|...{ Det|
|00002160| 65 72 6d 69 6e 65 20 23 | 20 6f 66 20 72 6f 77 73 |ermine #| of rows|
|00002170| 20 69 6e 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 | in the |selected|
|00002180| 20 72 61 6e 67 65 20 7d | 0d 45 4e 44 20 46 55 4e | range }|.END FUN|
|00002190| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|000021a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 43 52 |********|***** CR|
|000021c0| 45 41 54 45 5f 43 48 41 | 52 54 20 2a 2a 2a 2a 2a |EATE_CHA|RT *****|
|000021d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 20 20 |********|*****.  |
|00002200| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 63 72 |This fun|ction cr|
|00002210| 65 61 74 65 73 20 6f 75 | 72 20 43 61 73 68 20 46 |eates ou|r Cash F|
|00002220| 6c 6f 77 20 63 68 61 72 | 74 2e 20 20 54 68 65 20 |low char|t.  The |
|00002230| 63 68 61 72 74 20 74 79 | 70 65 20 69 73 20 66 69 |chart ty|pe is fi|
|00002240| 72 73 74 20 73 70 65 63 | 69 66 69 65 64 20 61 73 |rst spec|ified as|
|00002250| 20 61 20 6c 69 6e 65 20 | 67 72 61 70 68 20 74 68 | a line |graph th|
|00002260| 65 6e 0d 20 20 74 68 65 | 20 66 6f 72 65 67 72 6f |en.  the| foregro|
|00002270| 75 6e 64 20 61 6e 64 20 | 62 61 63 6b 67 72 6f 75 |und and |backgrou|
|00002280| 6e 64 20 63 6f 6c 6f 72 | 73 20 61 72 65 20 73 70 |nd color|s are sp|
|00002290| 65 63 69 66 69 65 64 2e | 20 20 54 68 65 20 46 52 |ecified.|  The FR|
|000022a0| 41 43 20 66 75 6e 63 74 | 69 6f 6e 20 61 6c 6c 6f |AC funct|ion allo|
|000022b0| 77 73 20 75 73 20 74 6f | 20 70 6f 73 69 74 69 6f |ws us to| positio|
|000022c0| 6e 20 6f 75 72 0d 20 20 | 67 72 61 70 68 20 61 6e |n our.  |graph an|
|000022d0| 79 77 68 65 72 65 20 6f | 6e 20 74 68 65 20 73 63 |ywhere o|n the sc|
|000022e0| 72 65 65 6e 20 28 6e 6f | 72 6d 61 6c 6c 79 20 79 |reen (no|rmally y|
|000022f0| 6f 75 20 61 72 65 20 6c | 69 6d 69 74 65 64 20 74 |ou are l|imited t|
|00002300| 6f 20 63 65 6c 6c 20 6c | 6f 63 61 74 69 6f 6e 73 |o cell l|ocations|
|00002310| 29 2e 0d 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |).. ****|********|
|00002320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002330| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002340| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002350| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002360| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002370| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 46 55 4e 43 54 |********|}..FUNCT|
|00002380| 49 4f 4e 20 43 52 45 41 | 54 45 5f 43 48 41 52 54 |ION CREA|TE_CHART|
|00002390| 28 29 0d 09 55 4e 53 45 | 4c 45 43 54 09 09 09 09 |()..UNSE|LECT....|
|000023a0| 09 09 09 09 09 7b 20 55 | 6e 73 65 6c 65 63 74 20 |.....{ U|nselect |
|000023b0| 61 6e 79 20 73 65 6c 65 | 63 74 65 64 20 69 74 65 |any sele|cted ite|
|000023c0| 6d 73 20 6f 72 20 63 65 | 6c 6c 73 20 7d 0d 09 41 |ms or ce|lls }..A|
|000023d0| 64 64 20 43 68 61 72 74 | 20 52 61 6e 67 65 20 66 |dd Chart| Range f|
|000023e0| 72 61 63 28 4b 31 2e 2e | 51 32 31 3b 31 3b 30 3b |rac(K1..|Q21;1;0;|
|000023f0| 39 38 3b 31 32 36 29 20 | 09 09 7b 20 43 72 65 61 |98;126) |..{ Crea|
|00002400| 74 65 20 61 20 63 68 61 | 72 74 20 73 70 65 63 69 |te a cha|rt speci|
|00002410| 66 79 69 6e 67 20 74 68 | 65 20 6c 6f 63 61 74 69 |fying th|e locati|
|00002420| 6f 6e 2e 2e 2e 7d 0d 09 | 09 55 73 69 6e 67 20 52 |on...}..|.Using R|
|00002430| 41 4e 47 45 28 4d 41 4b | 45 52 41 4e 47 45 28 37 |ANGE(MAK|ERANGE(7|
|00002440| 3b 32 3b 39 3b 6c 61 73 | 74 5f 72 6f 77 29 29 09 |;2;9;las|t_row)).|
|00002450| 09 7b 20 2e 2e 2e 61 6e | 64 20 74 68 65 20 64 61 |.{ ...an|d the da|
|00002460| 74 61 20 72 61 6e 67 65 | 20 7d 0d 09 53 45 4c 45 |ta range| }..SELE|
|00002470| 43 54 20 4f 42 4a 45 43 | 54 20 31 09 09 09 09 09 |CT OBJEC|T 1.....|
|00002480| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 68 65 20 63 |..{ Sele|ct the c|
|00002490| 68 61 72 74 20 7d 0d 09 | 4c 49 4e 45 09 09 09 09 |hart }..|LINE....|
|000024a0| 09 09 09 09 09 09 7b 20 | 4d 61 6b 65 20 74 68 65 |......{ |Make the|
|000024b0| 20 63 68 61 72 74 20 61 | 20 6c 69 6e 65 20 67 72 | chart a| line gr|
|000024c0| 61 70 68 20 7d 0d 09 56 | 45 52 54 49 43 41 4c 20 |aph }..V|ERTICAL |
|000024d0| 43 48 41 52 54 20 50 41 | 52 53 49 4e 47 09 09 09 |CHART PA|RSING...|
|000024e0| 09 09 09 7b 20 53 70 65 | 63 69 66 79 20 76 65 72 |...{ Spe|cify ver|
|000024f0| 74 69 63 61 6c 20 70 61 | 72 73 69 6e 67 20 7d 0d |tical pa|rsing }.|
|00002500| 09 53 45 4c 45 43 54 20 | 43 48 41 52 54 20 31 20 |.SELECT |CHART 1 |
|00002510| 53 45 52 49 45 53 20 31 | 09 09 09 09 09 09 7b 20 |SERIES 1|......{ |
|00002520| 53 65 6c 65 63 74 20 74 | 68 65 20 70 6c 61 6e 20 |Select t|he plan |
|00002530| 6c 69 6e 65 20 69 6e 20 | 6c 65 67 65 6e 64 20 7d |line in |legend }|
|00002540| 0d 09 4c 49 4e 45 20 46 | 47 20 31 31 31 34 31 31 |..LINE F|G 111411|
|00002550| 32 30 09 09 09 09 09 09 | 09 7b 20 53 65 74 20 74 |20......|.{ Set t|
|00002560| 68 65 20 6c 69 6e 65 20 | 63 6f 6c 6f 72 20 7d 0d |he line |color }.|
|00002570| 09 4c 49 4e 45 20 50 41 | 54 54 45 52 4e 20 35 09 |.LINE PA|TTERN 5.|
|00002580| 09 09 09 09 09 09 09 7b | 20 53 65 74 20 74 68 65 |.......{| Set the|
|00002590| 20 6c 69 6e 65 20 70 61 | 74 74 65 72 6e 20 7d 0d | line pa|ttern }.|
|000025a0| 09 53 45 4c 45 43 54 20 | 43 48 41 52 54 20 31 20 |.SELECT |CHART 1 |
|000025b0| 41 58 49 53 20 31 09 09 | 09 09 09 09 7b 20 53 65 |AXIS 1..|....{ Se|
|000025c0| 6c 65 63 74 20 74 68 65 | 20 78 2d 61 78 69 73 20 |lect the| x-axis |
|000025d0| 7d 0d 09 49 46 20 6c 61 | 73 74 5f 72 6f 77 20 3e |}..IF la|st_row >|
|000025e0| 20 32 30 09 09 09 09 09 | 09 09 7b 20 49 66 20 74 | 20.....|..{ If t|
|000025f0| 68 65 72 65 20 61 72 65 | 20 74 6f 6f 20 6d 61 6e |here are| too man|
|00002600| 79 20 68 61 73 68 20 6d | 61 72 6b 73 20 6f 6e 20 |y hash m|arks on |
|00002610| 74 68 65 2e 2e 2e 7d 0d | 09 09 48 49 44 45 20 41 |the...}.|..HIDE A|
|00002620| 58 49 53 20 48 41 53 48 | 09 09 09 09 09 09 09 7b |XIS HASH|.......{|
|00002630| 20 2e 2e 2e 58 2d 61 78 | 69 73 2c 20 68 69 64 65 | ...X-ax|is, hide|
|00002640| 20 74 68 65 6d 20 64 75 | 65 20 74 6f 20 63 72 6f | them du|e to cro|
|00002650| 77 64 69 6e 67 20 7d 0d | 09 45 4e 44 20 49 46 0d |wding }.|.END IF.|
|00002660| 09 41 58 49 53 20 4d 41 | 4a 4f 52 20 47 52 49 44 |.AXIS MA|JOR GRID|
|00002670| 20 46 47 20 30 09 09 09 | 09 09 09 7b 20 44 65 66 | FG 0...|...{ Def|
|00002680| 69 6e 65 20 4d 61 6a 6f | 72 20 47 72 69 64 20 66 |ine Majo|r Grid f|
|00002690| 6f 72 65 67 72 6f 75 6e | 64 20 63 6f 6c 6f 72 20 |oregroun|d color |
|000026a0| 7d 0d 09 41 58 49 53 20 | 4d 41 4a 4f 52 20 47 52 |}..AXIS |MAJOR GR|
|000026b0| 49 44 20 42 47 20 31 36 | 37 37 37 32 31 35 09 09 |ID BG 16|777215..|
|000026c0| 09 09 09 7b 20 44 65 66 | 69 6e 65 20 4d 61 6a 6f |...{ Def|ine Majo|
|000026d0| 72 20 47 72 69 64 20 62 | 61 63 6b 67 72 6f 75 6e |r Grid b|ackgroun|
|000026e0| 64 20 63 6f 6c 6f 72 20 | 7d 0d 09 41 58 49 53 20 |d color |}..AXIS |
|000026f0| 4d 41 4a 4f 52 20 47 52 | 49 44 20 50 41 54 54 45 |MAJOR GR|ID PATTE|
|00002700| 52 4e 20 30 09 09 09 09 | 09 7b 20 44 65 66 69 6e |RN 0....|.{ Defin|
|00002710| 65 20 4d 61 6a 6f 72 20 | 47 72 69 64 20 70 61 74 |e Major |Grid pat|
|00002720| 74 65 72 6e 20 7d 0d 09 | 41 58 49 53 20 4d 41 4a |tern }..|AXIS MAJ|
|00002730| 4f 52 20 47 52 49 44 20 | 57 49 44 54 48 20 35 09 |OR GRID |WIDTH 5.|
|00002740| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 4d 61 |.....{ D|efine Ma|
|00002750| 6a 6f 72 20 47 72 69 64 | 20 77 69 64 74 68 20 7d |jor Grid| width }|
|00002760| 0d 09 41 58 49 53 20 4d | 49 4e 4f 52 20 47 52 49 |..AXIS M|INOR GRI|
|00002770| 44 20 46 47 20 31 32 33 | 30 33 32 39 31 09 09 09 |D FG 123|03291...|
|00002780| 09 09 7b 20 44 65 66 69 | 6e 65 20 4d 69 6e 6f 72 |..{ Defi|ne Minor|
|00002790| 20 47 72 69 64 20 66 6f | 72 65 67 72 6f 75 6e 64 | Grid fo|reground|
|000027a0| 20 63 6f 6c 6f 72 20 7d | 0d 09 41 58 49 53 20 4d | color }|..AXIS M|
|000027b0| 49 4e 4f 52 20 47 52 49 | 44 20 42 47 20 31 36 37 |INOR GRI|D BG 167|
|000027c0| 37 37 32 31 35 09 09 09 | 09 09 7b 20 44 65 66 69 |77215...|..{ Defi|
|000027d0| 6e 65 20 4d 69 6e 6f 72 | 20 47 72 69 64 20 62 61 |ne Minor| Grid ba|
|000027e0| 63 6b 67 72 6f 75 6e 64 | 20 63 6f 6c 6f 72 20 7d |ckground| color }|
|000027f0| 0d 09 41 58 49 53 20 4d | 49 4e 4f 52 20 47 52 49 |..AXIS M|INOR GRI|
|00002800| 44 20 50 41 54 54 45 52 | 4e 20 30 09 09 09 09 09 |D PATTER|N 0.....|
|00002810| 7b 20 44 65 66 69 6e 65 | 20 4d 69 6e 6f 72 20 47 |{ Define| Minor G|
|00002820| 72 69 64 20 70 61 74 74 | 65 72 6e 20 7d 0d 09 41 |rid patt|ern }..A|
|00002830| 58 49 53 20 4d 49 4e 4f | 52 20 47 52 49 44 20 57 |XIS MINO|R GRID W|
|00002840| 49 44 54 48 20 30 09 09 | 09 09 09 09 7b 20 44 65 |IDTH 0..|....{ De|
|00002850| 66 69 6e 65 20 4d 69 6e | 6f 72 20 47 72 69 64 20 |fine Min|or Grid |
|00002860| 77 69 64 74 68 20 7d 0d | 09 53 45 4c 45 43 54 20 |width }.|.SELECT |
|00002870| 43 48 41 52 54 20 31 20 | 41 58 49 53 20 33 09 09 |CHART 1 |AXIS 3..|
|00002880| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 74 68 65 |....{ Se|lect the|
|00002890| 20 79 2d 61 78 69 73 20 | 7d 0d 09 41 58 49 53 20 | y-axis |}..AXIS |
|000028a0| 4d 41 4a 4f 52 20 47 52 | 49 44 20 46 47 20 30 09 |MAJOR GR|ID FG 0.|
|000028b0| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 4d 61 |.....{ D|efine Ma|
|000028c0| 6a 6f 72 20 47 72 69 64 | 20 66 6f 72 65 67 72 6f |jor Grid| foregro|
|000028d0| 75 6e 64 20 63 6f 6c 6f | 72 20 7d 0d 09 41 58 49 |und colo|r }..AXI|
|000028e0| 53 20 4d 41 4a 4f 52 20 | 47 52 49 44 20 42 47 20 |S MAJOR |GRID BG |
|000028f0| 31 36 37 37 37 32 31 35 | 09 09 09 09 09 7b 20 44 |16777215|.....{ D|
|00002900| 65 66 69 6e 65 20 4d 61 | 6a 6f 72 20 47 72 69 64 |efine Ma|jor Grid|
|00002910| 20 62 61 63 6b 67 72 6f | 75 6e 64 20 63 6f 6c 6f | backgro|und colo|
|00002920| 72 20 7d 0d 09 41 58 49 | 53 20 4d 41 4a 4f 52 20 |r }..AXI|S MAJOR |
|00002930| 47 52 49 44 20 50 41 54 | 54 45 52 4e 20 31 09 09 |GRID PAT|TERN 1..|
|00002940| 09 09 09 7b 20 44 65 66 | 69 6e 65 20 4d 61 6a 6f |...{ Def|ine Majo|
|00002950| 72 20 47 72 69 64 20 70 | 61 74 74 65 72 6e 20 7d |r Grid p|attern }|
|00002960| 0d 09 41 58 49 53 20 4d | 41 4a 4f 52 20 47 52 49 |..AXIS M|AJOR GRI|
|00002970| 44 20 57 49 44 54 48 20 | 35 09 09 09 09 09 09 7b |D WIDTH |5......{|
|00002980| 20 44 65 66 69 6e 65 20 | 4d 61 6a 6f 72 20 47 72 | Define |Major Gr|
|00002990| 69 64 20 77 69 64 74 68 | 20 7d 0d 09 41 58 49 53 |id width| }..AXIS|
|000029a0| 20 4d 49 4e 4f 52 20 47 | 52 49 44 20 46 47 20 30 | MINOR G|RID FG 0|
|000029b0| 09 09 09 09 09 09 7b 20 | 44 65 66 69 6e 65 20 4d |......{ |Define M|
|000029c0| 69 6e 6f 72 20 47 72 69 | 64 20 66 6f 72 65 67 72 |inor Gri|d foregr|
|000029d0| 6f 75 6e 64 20 63 6f 6c | 6f 72 20 7d 0d 09 41 58 |ound col|or }..AX|
|000029e0| 49 53 20 4d 49 4e 4f 52 | 20 47 52 49 44 20 42 47 |IS MINOR| GRID BG|
|000029f0| 20 31 36 37 37 37 32 31 | 35 09 09 09 09 09 7b 20 | 1677721|5.....{ |
|00002a00| 44 65 66 69 6e 65 20 4d | 69 6e 6f 72 20 47 72 69 |Define M|inor Gri|
|00002a10| 64 20 62 61 63 6b 67 72 | 6f 75 6e 64 20 63 6f 6c |d backgr|ound col|
|00002a20| 6f 72 20 7d 0d 09 41 58 | 49 53 20 4d 49 4e 4f 52 |or }..AX|IS MINOR|
|00002a30| 20 47 52 49 44 20 50 41 | 54 54 45 52 4e 20 31 09 | GRID PA|TTERN 1.|
|00002a40| 09 09 09 09 7b 20 44 65 | 66 69 6e 65 20 4d 69 6e |....{ De|fine Min|
|00002a50| 6f 72 20 47 72 69 64 20 | 70 61 74 74 65 72 6e 20 |or Grid |pattern |
|00002a60| 7d 0d 09 41 58 49 53 20 | 4d 49 4e 4f 52 20 47 52 |}..AXIS |MINOR GR|
|00002a70| 49 44 20 57 49 44 54 48 | 20 30 09 09 09 09 09 09 |ID WIDTH| 0......|
|00002a80| 7b 20 44 65 66 69 6e 65 | 20 4d 69 6e 6f 72 20 47 |{ Define| Minor G|
|00002a90| 72 69 64 20 77 69 64 74 | 68 20 7d 0d 09 53 45 4c |rid widt|h }..SEL|
|00002aa0| 45 43 54 20 4f 42 4a 45 | 43 54 20 31 09 09 09 09 |ECT OBJE|CT 1....|
|00002ab0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 74 68 65 20 |...{ Sel|ect the |
|00002ac0| 63 68 61 72 74 20 7d 0d | 09 53 45 4c 45 43 54 20 |chart }.|.SELECT |
|00002ad0| 4d 4f 52 45 20 52 41 4e | 47 45 20 47 31 09 09 09 |MORE RAN|GE G1...|
|00002ae0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 74 68 65 20 |...{ Sel|ect the |
|00002af0| 63 68 61 72 74 20 74 69 | 74 6c 65 20 63 65 6c 6c |chart ti|tle cell|
|00002b00| 20 7d 0d 09 54 49 54 4c | 45 20 52 41 4e 47 45 09 | }..TITL|E RANGE.|
|00002b10| 09 09 09 09 09 09 09 7b | 20 44 65 73 69 67 6e 61 |.......{| Designa|
|00002b20| 74 65 20 74 68 65 20 74 | 69 74 6c 65 20 7d 0d 09 |te the t|itle }..|
|00002b30| 54 49 54 4c 45 20 43 45 | 4e 54 45 52 09 09 09 09 |TITLE CE|NTER....|
|00002b40| 09 09 09 09 7b 20 43 65 | 6e 74 65 72 20 74 68 65 |....{ Ce|nter the|
|00002b50| 20 74 69 74 6c 65 20 61 | 74 20 74 68 65 20 74 6f | title a|t the to|
|00002b60| 70 20 6f 66 20 74 68 65 | 20 63 68 61 72 74 20 7d |p of the| chart }|
|00002b70| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 52 |..SELECT| RANGE R|
|00002b80| 31 09 09 09 09 09 09 09 | 7b 20 53 65 6c 65 63 74 |1.......|{ Select|
|00002b90| 20 63 65 6c 6c 20 74 6f | 20 6d 6f 76 65 20 76 69 | cell to| move vi|
|00002ba0| 65 77 20 74 6f 20 63 68 | 61 72 74 20 61 72 65 61 |ew to ch|art area|
|00002bb0| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00002bc0| 20 4b 31 09 09 09 09 09 | 09 09 7b 20 53 65 6c 65 | K1.....|..{ Sele|
|00002bd0| 63 74 20 63 65 6c 6c 20 | 74 6f 20 6d 6f 76 65 20 |ct cell |to move |
|00002be0| 76 69 65 77 20 74 6f 20 | 63 68 61 72 74 20 61 72 |view to |chart ar|
|00002bf0| 65 61 20 7d 0d 09 55 4e | 53 45 4c 45 43 54 09 09 |ea }..UN|SELECT..|
|00002c00| 09 09 09 09 09 09 09 7b | 20 55 6e 73 65 6c 65 63 |.......{| Unselec|
|00002c10| 74 20 61 6e 79 20 73 65 | 6c 65 63 74 65 64 20 63 |t any se|lected c|
|00002c20| 65 6c 6c 73 20 6f 72 20 | 69 74 65 6d 73 20 7d 0d |ells or |items }.|
|00002c30| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|00002c40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c60| 2a 2a 2a 2a 20 41 53 4b | 5f 54 4f 5f 43 4f 50 59 |**** ASK|_TO_COPY|
|00002c70| 20 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a | *******|********|
|00002c80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ca0| 2a 2a 2a 2a 0d 20 20 54 | 68 69 73 20 66 75 6e 63 |****.  T|his func|
|00002cb0| 74 69 6f 6e 20 64 69 73 | 70 6c 61 79 73 20 61 20 |tion dis|plays a |
|00002cc0| 6d 6f 64 61 6c 20 64 69 | 61 6c 6f 67 20 62 6f 78 |modal di|alog box|
|00002cd0| 20 77 68 69 63 68 20 61 | 73 6b 73 20 69 66 20 79 | which a|sks if y|
|00002ce0| 6f 75 20 77 61 6e 74 20 | 74 6f 20 63 6c 6f 73 65 |ou want |to close|
|00002cf0| 20 74 68 65 20 66 69 6c | 65 2e 20 20 49 66 20 79 | the fil|e.  If y|
|00002d00| 6f 75 20 63 68 6f 6f 73 | 65 0d 20 20 22 59 65 73 |ou choos|e.  "Yes|
|00002d10| 22 2c 20 74 68 65 20 63 | 68 61 72 74 20 69 73 20 |", the c|hart is |
|00002d20| 63 6f 70 69 65 64 20 74 | 6f 20 74 68 65 20 63 6c |copied t|o the cl|
|00002d30| 69 70 62 6f 61 72 64 20 | 61 6e 64 20 74 68 65 20 |ipboard |and the |
|00002d40| 66 69 6c 65 20 69 73 20 | 63 6c 6f 73 65 64 2e 20 |file is |closed. |
|00002d50| 20 49 66 20 79 6f 75 20 | 63 68 6f 6f 73 65 20 22 | If you |choose "|
|00002d60| 4e 6f 22 2c 20 74 68 65 | 20 64 69 61 6c 6f 67 0d |No", the| dialog.|
|00002d70| 20 20 64 69 73 61 70 70 | 65 61 72 73 20 61 6e 64 |  disapp|ears and|
|00002d80| 20 74 68 65 20 73 63 72 | 69 70 74 20 74 65 72 6d | the scr|ipt term|
|00002d90| 69 6e 61 74 65 73 20 77 | 69 74 68 20 74 68 65 20 |inates w|ith the |
|00002da0| 66 69 6c 65 20 6f 70 65 | 6e 2e 0d 20 2a 2a 2a 2a |file ope|n.. ****|
|00002db0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002dc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002dd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002de0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002df0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e10| 7d 0d 0d 46 55 4e 43 54 | 49 4f 4e 20 41 53 4b 5f |}..FUNCT|ION ASK_|
|00002e20| 54 4f 5f 43 4f 50 59 28 | 29 0d 09 4e 45 57 20 4d |TO_COPY(|)..NEW M|
|00002e30| 4f 44 41 4c 20 44 49 41 | 4c 4f 47 20 42 4f 58 20 |ODAL DIA|LOG BOX |
|00002e40| 41 54 20 28 2d 31 3b 2d | 31 29 28 34 2e 35 20 49 |AT (-1;-|1)(4.5 I|
|00002e50| 4e 43 48 3b 31 2e 35 20 | 49 4e 43 48 29 7b 20 43 |NCH;1.5 |INCH){ C|
|00002e60| 72 65 61 74 65 20 61 20 | 63 65 6e 74 65 72 65 64 |reate a |centered|
|00002e70| 20 6d 6f 64 61 6c 20 64 | 69 61 6c 6f 67 20 62 6f | modal d|ialog bo|
|00002e80| 78 20 7d 0d 09 41 44 44 | 20 54 45 58 54 20 22 43 |x }..ADD| TEXT "C|
|00002e90| 6f 70 79 20 63 68 61 72 | 74 20 74 6f 20 43 6c 69 |opy char|t to Cli|
|00002ea0| 70 62 6f 61 72 64 20 61 | 6e 64 20 63 6c 6f 73 65 |pboard a|nd close|
|00002eb0| 20 77 6f 72 6b 73 68 65 | 65 74 20 77 69 74 68 6f | workshe|et witho|
|00002ec0| 75 74 20 73 61 76 69 6e | 67 3f 22 20 0d 09 09 41 |ut savin|g?" ...A|
|00002ed0| 54 20 28 2e 31 32 35 20 | 49 4e 43 48 3b 20 2e 31 |T (.125 |INCH; .1|
|00002ee0| 32 35 20 49 4e 43 48 29 | 20 2b 20 28 34 2e 32 35 |25 INCH)| + (4.25|
|00002ef0| 20 49 4e 43 48 3b 20 2e | 35 20 49 4e 43 48 29 09 | INCH; .|5 INCH).|
|00002f00| 7b 20 50 6c 61 63 65 20 | 74 65 78 74 20 69 6e 74 |{ Place |text int|
|00002f10| 6f 20 64 69 61 6c 6f 67 | 20 62 6f 78 20 7d 0d 09 |o dialog| box }..|
|00002f20| 4e 4f 20 4c 49 4e 45 20 | 42 4f 52 44 45 52 09 09 |NO LINE |BORDER..|
|00002f30| 09 09 09 09 09 09 7b 20 | 54 75 72 6e 20 6f 66 66 |......{ |Turn off|
|00002f40| 20 6c 69 6e 65 20 62 6f | 72 64 65 72 20 66 6f 72 | line bo|rder for|
|00002f50| 20 74 65 78 74 20 6f 62 | 6a 65 63 74 20 7d 0d 09 | text ob|ject }..|
|00002f60| 41 44 44 20 50 55 53 48 | 20 42 55 54 54 4f 4e 20 |ADD PUSH| BUTTON |
|00002f70| 22 20 20 20 20 4e 6f 20 | 20 20 20 22 3b 20 22 20 |"    No |   "; " |
|00002f80| 20 20 20 59 65 73 20 20 | 20 20 22 20 41 54 20 09 |   Yes  |  " AT .|
|00002f90| 7b 20 41 64 64 20 4e 6f | 20 61 6e 64 20 59 65 73 |{ Add No| and Yes|
|00002fa0| 20 62 75 74 74 6f 6e 73 | 20 7d 0d 09 09 28 33 2e | buttons| }...(3.|
|00002fb0| 32 35 20 49 4e 43 48 3b | 20 2e 36 32 35 20 49 4e |25 INCH;| .625 IN|
|00002fc0| 43 48 29 20 2b 20 28 31 | 20 49 4e 43 48 3b 20 2e |CH) + (1| INCH; .|
|00002fd0| 37 35 20 49 4e 43 48 29 | 0d 09 53 45 4c 45 43 54 |75 INCH)|..SELECT|
|00002fe0| 20 43 4f 4e 54 52 4f 4c | 20 32 09 09 09 09 09 09 | CONTROL| 2......|
|00002ff0| 09 7b 20 53 65 6c 65 63 | 74 20 4e 6f 20 62 75 74 |.{ Selec|t No but|
|00003000| 74 6f 6e 20 7d 0d 09 44 | 49 41 4c 4f 47 20 43 41 |ton }..D|IALOG CA|
|00003010| 4e 43 45 4c 20 50 55 53 | 48 20 42 55 54 54 4f 4e |NCEL PUS|H BUTTON|
|00003020| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 62 75 |.....{ D|efine bu|
|00003030| 74 74 6f 6e 20 61 73 20 | 61 20 63 61 6e 63 65 6c |tton as |a cancel|
|00003040| 20 62 75 74 74 6f 6e 20 | 7d 0d 09 53 43 52 49 50 | button |}..SCRIP|
|00003050| 54 20 22 27 43 61 73 68 | 20 46 6c 6f 77 20 73 63 |T "'Cash| Flow sc|
|00003060| 72 69 70 74 3a 64 6f 6e | 65 27 20 3d 20 30 22 09 |ript:don|e' = 0".|
|00003070| 09 09 7b 20 49 66 20 70 | 72 65 73 73 65 64 2c 20 |..{ If p|ressed, |
|00003080| 64 6f 6e 65 20 3d 20 30 | 20 7d 0d 09 53 45 4c 45 |done = 0| }..SELE|
|00003090| 43 54 20 43 4f 4e 54 52 | 4f 4c 20 33 09 09 09 09 |CT CONTR|OL 3....|
|000030a0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 59 65 73 20 |...{ Sel|ect Yes |
|000030b0| 62 75 74 74 6f 6e 20 7d | 0d 09 44 49 41 4c 4f 47 |button }|..DIALOG|
|000030c0| 20 44 45 46 41 55 4c 54 | 20 50 55 53 48 20 42 55 | DEFAULT| PUSH BU|
|000030d0| 54 54 4f 4e 09 09 09 09 | 09 7b 20 44 65 66 69 6e |TTON....|.{ Defin|
|000030e0| 65 20 62 75 74 74 6f 6e | 20 61 73 20 74 68 65 20 |e button| as the |
|000030f0| 64 65 66 61 75 6c 74 20 | 62 75 74 74 6f 6e 20 7d |default |button }|
|00003100| 0d 09 53 43 52 49 50 54 | 20 22 27 43 61 73 68 20 |..SCRIPT| "'Cash |
|00003110| 46 6c 6f 77 20 73 63 72 | 69 70 74 3a 64 6f 6e 65 |Flow scr|ipt:done|
|00003120| 27 20 3d 20 31 22 09 09 | 09 7b 20 49 66 20 70 72 |' = 1"..|.{ If pr|
|00003130| 65 73 73 65 64 2c 20 64 | 6f 6e 65 20 3d 20 31 20 |essed, d|one = 1 |
|00003140| 7d 0d 09 55 53 45 20 44 | 49 41 4c 4f 47 20 42 4f |}..USE D|IALOG BO|
|00003150| 58 09 09 09 09 09 09 09 | 09 7b 20 44 69 73 70 6c |X.......|.{ Displ|
|00003160| 61 79 20 64 69 61 6c 6f | 67 20 6f 6e 2d 73 63 72 |ay dialo|g on-scr|
|00003170| 65 65 6e 20 7d 0d 09 49 | 46 20 64 6f 6e 65 20 3d |een }..I|F done =|
|00003180| 20 31 09 09 09 09 09 09 | 09 09 7b 20 49 66 20 64 | 1......|..{ If d|
|00003190| 6f 6e 65 20 3d 20 31 20 | 28 59 65 73 20 77 61 73 |one = 1 |(Yes was|
|000031a0| 20 70 72 65 73 73 65 64 | 29 20 7d 0d 09 09 53 45 | pressed|) }...SE|
|000031b0| 4c 45 43 54 20 43 48 41 | 52 54 20 31 09 09 09 09 |LECT CHA|RT 1....|
|000031c0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 63 68 61 72 |...{ Sel|ect char|
|000031d0| 74 20 7d 0d 09 09 43 4f | 50 59 09 09 09 09 09 09 |t }...CO|PY......|
|000031e0| 09 09 09 7b 20 43 6f 70 | 79 20 74 6f 20 74 68 65 |...{ Cop|y to the|
|000031f0| 20 63 6c 69 70 62 6f 61 | 72 64 20 7d 0d 09 09 43 | clipboa|rd }...C|
|00003200| 4c 4f 53 45 20 4e 4f 57 | 09 09 09 09 09 09 09 09 |LOSE NOW|........|
|00003210| 7b 20 43 6c 6f 73 65 20 | 73 68 65 65 74 20 77 69 |{ Close |sheet wi|
|00003220| 74 68 6f 75 74 20 73 61 | 76 69 6e 67 20 7d 0d 09 |thout sa|ving }..|
|00003230| 45 4e 44 20 49 46 09 09 | 09 09 09 09 09 09 09 7b |END IF..|.......{|
|00003240| 20 45 6e 64 20 6c 6f 67 | 69 63 61 6c 20 49 46 20 | End log|ical IF |
|00003250| 7d 0d 45 4e 44 20 46 55 | 4e 43 54 49 4f 4e 0d 0d |}.END FU|NCTION..|
|00003260| 7b 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |{*******|********|
|00003270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003280| 2a 2a 2a 2a 2a 2a 20 45 | 4e 44 20 53 43 52 49 50 |****** E|ND SCRIP|
|00003290| 54 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T ******|********|
|000032a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032c0| 2a 2a 2a 2a 2a 7d 0d 00 |                         |*****}..|        |
+--------+-------------------------+-------------------------+--------+--------+